(1)服务器配置： 1 2 3 4 5 6 7 8 9 10 11 12 13 [root@localhost ~]# cd /usr/local/src/ [root@localhost src]# wget [root@localhost src]# rpm -ivh mysql57-community-release-el7-8.noarch.rpm mysql-community-client-5.7.30-1.el7.x86_64.rpm mysql-community-server-5.7.31-1.el7.x86_64.rpm 将这两个个rpm包， 0 rows affected (0.00 sec) #刷新权限 mysql flush privileges; Query OK， 0 rows affected (0.00 sec)#给新用户分权限mysql grant all privileges on *.* to user1@% with grant option; Query OK，密码 Query OK， mysql create user username@% identified by paswword;//添加新的用户。

0 rows affected (0.00 sec) Query OK。

0 rows affected (0.00 sec) #创建新的用户，以FTP形式导入：/var/cache/yum/x86_64/7/mysql57-community/packages/ [root@localhost src]# yum -y install mysql-server 等待时间较长 (2)重置密码与创建用户 1 2 3 4 5 #重启mysql服务 [root@VM-0-3-centos src]# service mysqld restart #重置密码 [root@localhost ~]# grep password /var/log/mysqld.log 1 2 3 4 5 6 7 8 9 10 #密码重置mysql alter user root@localhost identified by password;//密码重置，新的密码 Query OK，host from mysql.user; +---------------+-----------+ | user | host | +---------------+-----------+ | user1 | % | | mysql.session | localhost | | mysql.sys | localhost | | root | localhost | +---------------+-----------+ 4 rows in set (0.00 sec) mysql (4)实现在Navicat上连接 【常规】端配置参数 【SSH】端配置参数 ， 0 rows affected (0.00 sec) #刷新权限 mysql flush privileges; Query OK， 0 rows affected (0.00 sec) (3)查询MySql当前用户： 1 2 3 4 5 6 7 8 9 10 11 12 mysql select user，。